﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using FrmMain;
using MyKTVUtils;


namespace MyKTVService
{
    public class Service
    {
        /// <summary>
        /// 数据持久层对象
        /// </summary>
        Dao dao = new Dao();

        public List<Dictionary<string, object>> GetRemenber()
        {
            string sql = "select top 1 * from admin_info where admin_MAC = @admin_MAC order by admin_lastCheack desc";
            SqlParameter[] parame = { new SqlParameter("@admin_MAC",MACAdress.getThisMAC()) };
            string[] columns = { "admin_name" , "admin_pwd" };
            List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
            list = dao.DoDataReader(columns, sql, parame);
            return list;
        }

       
    }
}
